Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | RetailTransactionLineItem(TR_LTM_RTL_TRN) |
RetailTransactionLineItemGroupAssignmentID (PK) | Token identifier for a RetailTransactionLineItemGroupAssignment | ID_RTL_TRN_LN_ITM_GP_ASGMT | Identity | integer | |
TransactionID (FK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | RetailTransactionLineItemGroup(TR_RTL_LTMGP) |
LineItemGroupID (FK) | The unique identifier for this LineItemGroup within the bounds of the parent RetailTransaction. | ID_TRN_LTMGP | LineNumber | smallint | RetailTransactionLineItemGroup(TR_RTL_LTMGP) |
RetailTransactionLineItemSequenceNumber (FK) | The sequence number of line item within the context of this RetailTransaction. | IC_LN_ITM | LineNumber | smallint | RetailTransactionLineItem(TR_LTM_RTL_TRN) |
RetailUnitQuantity | A count of retail selling units from a RetailTransactionLineItem (actually from a SaleReturnLineItem subtype) that is referenced in this associative entity type. CAUTION: The value here is retail selling unit count NOT retail pricing unit count. So exercise caution if you are dealing with items sold 3 for $.49 - their retail selling units are 3 and their RETAIL PRICING is $.49 in a line item. | QU_RTL_UN | Quantity | DECIMAL(9,3) | |